SELECT "temp_zc_info".*,ORG_UNIT."ID" deptId,ORG_MEMBER."ID" memberId,CTP_ENUM_ITEM."ID" as statusName FROM "temp_zc_info" 
LEFT JOIN ORG_UNIT ON ORG_UNIT.CODE = "temp_zc_info"."code" AND ORG_UNIT.IS_ENABLE = 1 AND ORG_UNIT.IS_DELETED = 0
LEFT JOIN ORG_MEMBER ON ORG_MEMBER.CODE = "temp_zc_info"."cn" AND ORG_MEMBER.IS_ENABLE = 1 AND ORG_MEMBER.IS_DELETED = 0
LEFT JOIN FORMMAIN_0986 ON  FORMMAIN_0986.FIELD0001 = "temp_zc_info"."equip_code"
LEFT JOIN CTP_ENUM_ITEM ON CTP_ENUM_ITEM.SHOWVALUE = "temp_zc_info"."status_name" AND CTP_ENUM_ITEM.STATE = 1 AND CTP_ENUM_ITEM.OUTPUT_SWITCH = 1 AND 
CTP_ENUM_ITEM.REF_ENUMID = '-8285353862701692693'
WHERE FORMMAIN_0986.FIELD0001 is NULL